2013-03-22 - 5910.200 - Rel Notes - Contracts - Release 010 #BIReleases2013

Release Notes:

5910.200 - Contracts - SA215

Admin Info

Purpose
 Including Contract Information in SA215 report
Release No
 010
Submitted
 03-22-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Narendra K
Object(s) Tested By
 Narendra K

Report Name

SA215 - Sales Analysis By Region, Sales Org, Customer Group and Customer

‍BEx Query

ZMP_OPASA_Q016

NEC Crystal Reports Standards Check

1. SA215 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA215 NEC CR checklist has been sent to NEC and also attached here for reference.
SA215 NEC CR Standard Check List.xlsx

Summary Level Check

Test Conducted

Report Header
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 3,080,700
 3,080,700
 Pass
2
 Ship Rev
 31,542,208
 31,542,208
 Pass
3
 Open Qty
 3,376
 3,376
 Pass
4
 Open Rev
 35,045
 35,045
 Pass
5
 Cost
 13,181,371
 13,181,371
 Pass
6
 Comm
 893,035
 893,035
 Pass
7
 Royalty
 4,541,236
 4,541,236
 Pass
8
 Contrib
 13,061,456
 13,061,456
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 4,050,055
 4,050,055
 Pass
2
 Ship Rev
 44,579,749
 44,579,749
 Pass
3
 Open Qty
 795,295
 795,295
 Pass
4
 Open Rev
 9,214,997
 9,214,997
 Pass
5
 Cost
 18,753,268
 18,753,268
 Pass
6
 Comm
 1,181,961
 1,181,961
 Pass
7
 Royalty
 6,480,588
 6,480,588
 Pass
8
 Contrib
 18,555,696
 18,555,696
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 1,819,250
 1,819,250
 Pass
2
 Ship Rev
 17,923,109
 17,923,109
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 6,993,438
 6,993,438
 Pass
6
 Comm
 609,317
 609,317
 Pass
7
 Royalty
 2,271,941
 2,271,941
 Pass
8
 Contrib
 8,048,412
 8,048,412
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 5,207,443
 5,207,443
 Pass
2
 Ship Rev
 61,590,962
 61,590,962
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 20,086,092
 20,086,092
 Pass
6
 Comm
 1,769,692
 1,769,692
 Pass
7
 Royalty
 9,280,874
 9,280,874
 Pass
8
 Contrib
 30,454,304
 30,454,304
 Pass

Second Level Check

Grouping: Region > Sales Org > Customer Group > Customer

Test Conducted

Group: Emerging Markets
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 112,564
 112,564
 Pass
2
 Ship Rev
 1,616,463
 1,616,463
 Pass
3
 Open Qty
 425
 425
 Pass
4
 Open Rev
 5,523
 5,523
 Pass
5
 Cost
 488,797
 488,797
 Pass
6
 Comm
 9,998
 9,998
 Pass
7
 Royalty
 223,577
 223,577
 Pass
8
 Contrib
 894,091
 894,091
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 103,180
 103,180
 Pass
2
 Ship Rev
 1,403,166
 1,403,166
 Pass
3
 Open Qty
 60,000
 60,000
 Pass
4
 Open Rev
 882,953
 882,953
 Pass
5
 Cost
 503,264
 503,264
 Pass
6
 Comm
 8,287
 8,287
 Pass
7
 Royalty
 202,159
 202,159
 Pass
8
 Contrib
 689,456
 689,456
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 59,057
 59,057
 Pass
2
 Ship Rev
 835,799
 835,799
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 252,715
 252,715
 Pass
6
 Comm
 6,073
 6,073
 Pass
7
 Royalty
 133,778
 133,778
 Pass
8
 Contrib
 443,232
 443,232
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 168,503
 168,503
 Pass
2
 Ship Rev
 2,160,878
 2,160,878
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 689,877
 689,877
 Pass
6
 Comm
 10,478
 10,478
 Pass
7
 Royalty
 333,818
 333,818
 Pass
8
 Contrib
 1,126,705
 1,126,705
 Pass

Third Level Check

‍‍Test Conducted

Group: Emerging Markets > Australia Sales
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 13,063
 13,063
 Pass
2
 Ship Rev
 272,973
 272,973
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 62,605
 62,605
 Pass
6
 Comm
 9,386
 9,386
 Pass
7
 Royalty
 37,591
 37,591
 Pass
8
 Contrib
 163,392
 163,392
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 16,936
 16,936
 Pass
2
 Ship Rev
 275,948
 275,948
 Pass
3
 Open Qty
 3,354
 3,354
 Pass
4
 Open Rev
 65,458
 65,458
 Pass
5
 Cost
 78,281
 78,281
 Pass
6
 Comm
 8,089
 8,089
 Pass
7
 Royalty
 39,922
 39,922
 Pass
8
 Contrib
 150,655
 150,655
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 11,323
 11,323
 Pass
2
 Ship Rev
 243,910
 243,910
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 39,317
 39,317
 Pass
6
 Comm
 5,871
 5,871
 Pass
7
 Royalty
 37,960
 37,960
 Pass
8
 Contrib
 160,763
 160,763
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 19,338
 19,338
 Pass
2
 Ship Rev
 348,035
 348,035
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 63,279
 63,279
 Pass
6
 Comm
 10,026
 10,026
 Pass
7
 Royalty
 59,614
 59,614
 Pass
8
 Contrib
 215,117
 215,117
 Pass

Fourth Level Check

‍‍Test Conducted

Group: Emerging Markets > Australia Sales > Independent
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 3,070
 3,070
 Pass
2
 Ship Rev
 74,303
 74,303
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 10,863
 10,863
 Pass
6
 Comm
 2,809
 2,809
 Pass
7
 Royalty
 10,057
 10,057
 Pass
8
 Contrib
 50,123
 50,123
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 6,713
 6,713
 Pass
2
 Ship Rev
 114,980
 114,980
 Pass
3
 Open Qty
 622
 622
 Pass
4
 Open Rev
 14,551
 14,551
 Pass
5
 Cost
 21,008
 21,008
 Pass
6
 Comm
 4,178
 4,178
 Pass
7
 Royalty
 16,680
 16,680
 Pass
8
 Contrib
 73,114
 73,114
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 1,391
 1,391
 Pass
2
 Ship Rev
 33,008
 33,008
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 4,940
 4,940
 Pass
6
 Comm
 966
 966
 Pass
7
 Royalty
 5,618
 5,618
 Pass
8
 Contrib
 21,485
 21,485
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 755
 755
 Pass
2
 Ship Rev
 18,100
 18,100
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 2,316
 2,316
 Pass
6
 Comm
 645
 645
 Pass
7
 Royalty
 2,730
 2,730
 Pass
8
 Contrib
 12,408
 12,048
 Pass

Fifth Level Check

‍‍Test Conducted

Group: Emerging Markets > Australia Sales > Independent > BOX 13 PTY LTD-1013018
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 9
 9
 Pass
2
 Ship Rev
 194
 194
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 29
 29
 Pass
6
 Comm
 8
 8
 Pass
7
 Royalty
 39
 39
 Pass
8
 Contrib
 119
 119
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 18
 18
 Pass
2
 Ship Rev
 322
 322
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 62
 62
 Pass
6
 Comm
 13
 13
 Pass
7
 Royalty
 44
 44
 Pass
8
 Contrib
 203
 203
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 0
 0
 Pass
2
 Ship Rev
 0
 0
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 0
 0
 Pass
6
 Comm
 0
 0
 Pass
7
 Royalty
 0
 0
 Pass
8
 Contrib
 0
 0
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 0
 0
 Pass
2
 Ship Rev
 0
 0
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 0
 0
 Pass
6
 Comm
 0
 0
 Pass
7
 Royalty
 0
 0
 Pass
8
 Contrib
 0
 0
 Pass

Reference Document (Specification)

2013-03-15 - 5910.200 - Spec - Contract Reports